Search Results
Didn't find what you need in UNLOAD PLUS for DB2 11.2?
Search all docs.bmc.com documentation
The BMCTRANS table contains information that _SvIncludePlusContent-_RecovMngr_short 1 and _SvIncludePlusContent-_LogMstr_short 1 use for transaction recovery. The following table describes the contents of the BMCTRANS table. The table contains one row for each
https://docs.bmc.com/docs/adu11200/bmctrans-table-881421154.html
The BMC common utility tables contain information about the BMC utilities that you generate and submit through a BMC utility product. The following table lists the tables that each utility uses and each table’s default name and synonym: Table Default name Synonym
https://docs.bmc.com/docs/adu11200/common-utility-tables-881421147.html
The BMCHIST table contains information about completed executions of the BMC utilities for DB2. The following configuration or installation options control use of the BMCHIST table: HISTORY (for NGT Copy, NGT Recover, and UNLOAD PLUS) BMCHIST (for REORG PLUS
https://docs.bmc.com/docs/adu11200/bmchist-table-881421149.html
The BMCDICT table stores the compression dictionary during load or reorganization processing. The following table describes the contents of the BMCDICT table: Column name Data type Description UTILID CHAR(16) Utility identifier DBNAME CHAR(8) Database name TSNAME CHAR
https://docs.bmc.com/docs/adu11200/bmcdict-table-881421148.html
The BMC utilities use the BMCXCOPY table to track registered copies. The following table describes the contents of the BMCXCOPY table … copies Encrypted copies The BMCXCOPY table functions like SYSIBM.SYSCOPY except that IXNAME replaces TSNAME in BMCXCOPY. You must control
https://docs.bmc.com/docs/adu11200/bmcxcopy-table-881421156.html
The BMCUTIL table contains information about utilities that are currently running or started. The following table describes the contents of the BMCUTIL table. The utilities use the table to control the use of utility IDs. Each BMC utility must have a unique ID
https://docs.bmc.com/docs/adu11200/bmcutil-table-881421155.html
The BMCLGRNX table contains log ranges that show when a table space was open for updates. The following table describes the contents of the BMCLGRNX table: Column name Data type Description LGRDBID CHAR(2) DBID of the modified object LGRPSID CHAR(2) OBID
https://docs.bmc.com/docs/adu11200/bmclgrnx-table-881421150.html
The BMCSYNC table contains information about the status of the objects that the currently executing products are accessing. The BMCSYNC table synchronizes and controls access to Db2 spaces by concurrently executing BMC products. If you have more than one product
https://docs.bmc.com/docs/adu11200/bmcsync-table-881421151.html
This topic provides basic procedures for working with the common utility tables. To determine your site’s table names The names of the common utility tables can be changed during installation. To determine the names that your site uses, perform one of the following
https://docs.bmc.com/docs/adu11200/managing-common-utility-tables-881421212.html
This topic contains important information that you need to know about the BMCSYNC table: By default, DASD MANAGER PLUS uses the BMCSYNC table to synchronize access to Db2 spaces. However, if you want to turn this feature off, you may do so by specifying
https://docs.bmc.com/docs/adu11200/bmcsync-table-considerations-881421152.html
When a utility abends, rows might remain in the BMCSYNC table. On rare occasions, you might need to take action to control expansion of the BMCSYNC table. To control expansion of the BMCSYNC table Use one of the following methods to delete rows in the BMCSYNC table
https://docs.bmc.com/docs/adu11200/maintaining-the-bmcsync-table-881421215.html
When a utility abends, rows might remain in the BMCUTIL table. On rare occasions, you might need to take action to control expansion of the BMCUTIL table. To control expansion of the BMCUTIL table Use one of the following methods to delete rows from the BMCUTIL table
https://docs.bmc.com/docs/adu11200/maintaining-the-bmcutil-table-881421217.html
When a utility completes successfully, it inserts a row into the BMCHIST table. You can control expansion of this table by deleting old rows. If you use REORG PLUS, you can also control inserts into the BMCHIST table. To delete old rows from the BMCHIST table To delete
https://docs.bmc.com/docs/adu11200/maintaining-the-bmchist-table-881421214.html
Periodically, you should review BMCXCOPY and delete old rows to control its expansion. To control expansion of the BMCXCOPY table To delete all rows from the BMCXCOPY table that are older than 30 days, run an SQL DELETE statement, using the following statement
https://docs.bmc.com/docs/adu11200/maintaining-the-bmcxcopy-table-881421218.html
The following topics provide information about maintaining common utility tables in LOADPLUS: Common utility tables ||contentGoal … | |names of common utility tables, determining, table names, determining, tables, BMC, determining names, querying, SQL statements, querying
https://docs.bmc.com/docs/adu11200/maintaining-common-utility-tables-979551597.html
remain in the BMCDICT table. On rare occasions, you might need to take action to control expansion of the BMCDICT table. To control expansion of the BMCDICT table Delete any rows in the BMCUTIL table that you know are no longer valid. Do not delete any rows for instances
https://docs.bmc.com/docs/adu11200/maintaining-the-bmcdict-table-881421213.html
, is discussed on the following pages. You can optionally specify the table name used in the CREATE statement by specifying the INTO NAME clause. If you do not supply a table name, UNLOAD PLUS uses the name of the unloaded table. You can use the INTO list of columns to specify
https://docs.bmc.com/docs/adu11200/control-statements-to-load-teradata-tables-881421172.html
For each subsystem, use the following procedure to set up the SmartSwitch rules table and alias. This procedure uses sample DDL … : Value Guideline Database The default value is the database in which other BMC table spaces (for example, BMCUTIL and BMCSYNC
https://docs.bmc.com/docs/adu11200/setting-up-a-smartswitch-rules-table-979551612.html
keyword or FILTERPART), the drain information in this section applies to the participating partitions. UNLOAD PLUS locks tables only when all of the following conditions exist: You are unloading a nonpartitioned table space with multiple tables. The table space is not in UT
https://docs.bmc.com/docs/adu11200/drain-and-lock-table-processing-881421075.html
The SmartSwitch tracking table (BMCSSTRACKING) provides information on jobs executed via SmartSwitch. The table lists the following … table describes the contents of the BMCSSTRACKING table: Data type Description Column name Data type Description INSERT_TIMESTAMP
https://docs.bmc.com/docs/adu11200/smartswitch-tracking-table-979551526.html
This example illustrates unloading data from multiple tables in multiple table spaces. The SYSPRINT shows that UNLOAD PLUS generates … subsystem to provide zIIP processing. The following table describes the key command options that this job uses: Command options used in JCL
https://docs.bmc.com/docs/adu11200/example-9-unloading-from-multiple-table-spaces-881421123.html
The control statement generation feature of UNLOAD PLUS supports the following options for SQL/DS load processing: Loading a table that was previously created (SQL/DS-LOAD option) Creating a new SQL/DS table and load it (SQL/DS-LOAD option) Creating a new SQL/DS table
https://docs.bmc.com/docs/adu11200/control-statements-to-create-and-load-sql-ds-tables-881421167.html
The control statement generation feature of UNLOAD PLUS supports the following options for DB2 load processing: Loading a table that was previously created (DB2LOAD option or BMCLOAD option) Creating a new Db2 table and load it (Db2 option) Creating a new Db2 table
https://docs.bmc.com/docs/adu11200/control-statements-to-create-and-load-db2-tables-881421159.html
This job unloads multiple tables from a multi-table table space into one Db2 table with one UNLOAD command. There is a clustering index on the table space, which UNLOAD PLUS uses to sort the output records. The job also inserts a constant value of SALARIED, HRLY
https://docs.bmc.com/docs/adu11200/example-3-unloading-multiple-tables-to-a-single-data-set-881421117.html
In this example, UNLOAD PLUS unloads all of the data from an EBCDIC employee table space by using a Unicode encoding scheme (specified by using the UNICODE keyword). After unloading the data as Unicode, LOADPLUS loads it into identically defined tables on another Db2
https://docs.bmc.com/docs/adu11200/example-18-unloading-a-table-space-and-loading-data-as-unicode-881421132.html